DROP TABLE CRST_JTF_RS_SALESREPS;

CREATE TABLE CRST_JTF_RS_SALESREPS                                                                                                                                                    
(                                                                                                                                                                                
  SALESREP_ID                   NUMBER          NOT NULL,                                                                                                                        
  RESOURCE_ID                   NUMBER          NOT NULL,                                                                                                                        
  LAST_UPDATE_DATE              DATE            NOT NULL,                                                                                                                        
  LAST_UPDATED_BY               NUMBER          NOT NULL,                                                                                                                        
  CREATION_DATE                 DATE            NOT NULL,                                                                                                                        
  CREATED_BY                    NUMBER          NOT NULL,                                                                                                                        
  LAST_UPDATE_LOGIN             NUMBER,                                                                                                                                          
  SALES_CREDIT_TYPE_ID          NUMBER          NOT NULL,                                                                                                                        
  NAME                          VARCHAR2(240 BYTE),                                                                                                                              
  STATUS                        VARCHAR2(30 BYTE),                                                                                                                               
  START_DATE_ACTIVE             DATE            NOT NULL,                                                                                                                        
  END_DATE_ACTIVE               DATE,                                                                                                                                            
  GL_ID_REV                     NUMBER,                                                                                                                                          
  GL_ID_FREIGHT                 NUMBER,                                                                                                                                          
  GL_ID_REC                     NUMBER,                                                                                                                                          
  SET_OF_BOOKS_ID               NUMBER,                                                                                                                                          
  SALESREP_NUMBER               VARCHAR2(30 BYTE),                                                                                                                               
  ORG_ID                        NUMBER,
  EMAIL_ADDRESS                 VARCHAR2(30 BYTE),                                                                                                                               
  WH_UPDATE_DATE                DATE,                                                                                                                                            
  PERSON_ID                     NUMBER,                                                                                                                                          
  SALES_TAX_GEOCODE             VARCHAR2(30 BYTE),                                                                                                                               
  SALES_TAX_INSIDE_CITY_LIMITS  VARCHAR2(1 BYTE),                                                                                                                                
  OBJECT_VERSION_NUMBER         NUMBER          NOT NULL,                                                                                                                        
  ATTRIBUTE_CATEGORY            VARCHAR2(30 BYTE),                                                                                                                               
  ATTRIBUTE1                    VARCHAR2(150 BYTE),                                                                                                                              
  ATTRIBUTE2                    VARCHAR2(150 BYTE),                                                                                                                              
  ATTRIBUTE3                    VARCHAR2(150 BYTE),                                                                                                                              
  ATTRIBUTE4                    VARCHAR2(150 BYTE),                                                                                                                              
  ATTRIBUTE5                    VARCHAR2(150 BYTE),                                                                                                                              
  ATTRIBUTE6                    VARCHAR2(150 BYTE),                                                                                                                              
  ATTRIBUTE7                    VARCHAR2(150 BYTE),                                                                                                                              
  ATTRIBUTE8                    VARCHAR2(150 BYTE),                                                                                                                              
  ATTRIBUTE9                    VARCHAR2(150 BYTE),                                                                                                                              
  ATTRIBUTE10                   VARCHAR2(150 BYTE),                                                                                                                              
  ATTRIBUTE11                   VARCHAR2(150 BYTE),                                                                                                                              
  ATTRIBUTE12                   VARCHAR2(150 BYTE),                                                                                                                              
  ATTRIBUTE13                   VARCHAR2(150 BYTE),                                                                                                                              
  ATTRIBUTE14                   VARCHAR2(150 BYTE),                                                                                                                              
  ATTRIBUTE15                   VARCHAR2(150 BYTE),                                                                                                                              
  SECURITY_GROUP_ID             NUMBER,
  SALESREP_ID_N                 NUMBER,
  ORG_ID_N                      NUMBER                                                                                                                                           
);
